---
title: SAIF.Business.Claim SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# SAIF.Business.Claim SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004.md) | Insert a new 1502 DCBS transfer record | Inline | CL_1502_DCBS_TRANSFER | `cls1502Transfer` |
| [SQL-005](SQL-005.md) | Insert a new claim employee work address | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `clsClaimEmployeeWorkAddress` |
| [SQL-006](SQL-006.md) | Insert a new claim work-release-status record | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `clsClaimWorkReleaseStatus` |
| [SQL-007](SQL-007.md) | Insert a new claim work-status record | Inline | CL_CLAIM_WORK_STATUS | `clsClaimWorkStatus` |
| [SQL-008](SQL-008.md) | Insert a new injured body-part record | Inline | CL_WORKER_INJURED_BODY_PART | `clsWorkerInjuredBodyPart` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-009](SQL-009.md) | Retrieve unprocessed 1502 transfers for a claim | Inline | CL_1502_DCBS_TRANSFER | `cls1502Transfer` |
| [SQL-010](SQL-010.md) | Retrieve all unprocessed 1502 transfers | Inline | CL_1502_DCBS_TRANSFER | `cls1502Transfer` |
| [SQL-011](SQL-011.md) | Retrieve an active benefit schedule row | Inline | CL_BENEFIT_SCHEDULE | `clsActiveBenefitSchedule` |
| [SQL-012](SQL-012.md) | Retrieve the benefit payment for an active schedule | Inline | CL_BENEFIT_PAYMENT | `clsActiveBenefitSchedule` |
| [SQL-013](SQL-013.md) | Calculate aggravation-rights dates | Stored Proc | N/A | `clsAggRightDates` |
| [SQL-014](SQL-014.md) | Retrieve an in-progress award benefit payment | Inline | CL_BENEFIT_PAYMENT | `clsAwardBenefitPayment` |
| [SQL-015](SQL-015.md) | Retrieve award benefit payments by benefit type | Inline | CL_BENEFIT_PAYMENT | `clsAwardBenefitPaymentCollection` |
| [SQL-016](SQL-016.md) | Retrieve a benefit schedule row (twin class) | Inline | CL_BENEFIT_SCHEDULE | `clsBenefitSchedule` |
| [SQL-017](SQL-017.md) | Retrieve benefit payment for schedule (twin class) | Inline | CL_BENEFIT_PAYMENT | `clsBenefitSchedule` |
| [SQL-018](SQL-018.md) | Retrieve a claim employee work address | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `clsClaimEmployeeWorkAddress` |
| [SQL-019](SQL-019.md) | Execute caller-supplied dynamic claim-list SQL | Inline | (caller-determined) | `clsClaimListGenerator` |
| [SQL-020](SQL-020.md) | Retrieve the latest claim work-release-status row | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `clsClaimWorkReleaseStatus` |
| [SQL-021](SQL-021.md) | Retrieve the latest claim work-status row | Inline | CL_CLAIM_WORK_STATUS | `clsClaimWorkStatus` |
| [SQL-022](SQL-022.md) | Retrieve federal awards by claim and status | Inline | CL_FEDERAL_AWARD | `clsFederalAwardStatusCollection` |
| [SQL-023](SQL-023.md) | Retrieve federal awards by worker and status | Inline | CL_FEDERAL_AWARD, CL_INJURY_CLAIM | `clsFederalAwardStatusCollection` |
| [SQL-024](SQL-024.md) | Retrieve a federal benefit schedule row | Inline | CL_BENEFIT_SCHEDULE | `clsFederalBenefitSchedule` |
| [SQL-025](SQL-025.md) | Retrieve medically-stationary date | Stored Proc | N/A | `clsMedicallyStationaryDate` |
| [SQL-026](SQL-026.md) | Retrieve PPD body-part code table | Inline | CL_PPD_BODY_PART_CODE | `clsPPDBodyParts` |
| [SQL-027](SQL-027.md) | Retrieve PPD scheduled degree-award table | Inline | CL_PPD_SCHED_DEGREE_AWARD | `clsPPDScheduledDegreeAwards` |
| [SQL-028](SQL-028.md) | Retrieve PPD unscheduled degree-award bands | Inline | CL_PPD_UNSCHED_DEGREE_AWARD | `clsPPDUnscheduledDegreeAwards` |
| [SQL-029](SQL-029.md) | Retrieve medical reserve service types | Inline | CL_RESERVE_MED_SERV_TYPE_CODE, CL_RESERVE_MED_SERV_DESCR_CODE | `clsServiceTypeCollection` |
| [SQL-030](SQL-030.md) | Retrieve vocational reserve service types | Inline | CL_RESERVE_VOC_SERV_COST_CODE, CL_RESERVE_VOC_SERV_DESCR_CODE | `clsServiceTypeCollection` |
| [SQL-031](SQL-031.md) | Retrieve an active award for pending processing | Inline | CL_AWARD | `clsSetAwardPaymentPending` |
| [SQL-032](SQL-032.md) | Retrieve benefit payments for an award | Inline | CL_BENEFIT_PAYMENT | `clsSetAwardPaymentPending` |
| [SQL-033](SQL-033.md) | Calculate statutory weekly wage | Stored Proc | N/A | `clsStatutoryWeeklyWageCalculation` |
| [SQL-034](SQL-034.md) | Calculate timeliness of first payment | Stored Proc | N/A | `clsTimelinessOfFirstPayment` |
| [SQL-035](SQL-035.md) | Retrieve vocational service type code table | Inline | CL_RESERVE_VOC_SERV_TYPE_CODE | `clsVocationalServiceTypes` |
| [SQL-036](SQL-036.md) | Retrieve injured body parts for a claim | Inline | CL_WORKER_INJURED_BODY_PART | `clsWorkerInjuredBodyPartCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-037](SQL-037.md) | Update a 1502 DCBS transfer as processed | Inline | CL_1502_DCBS_TRANSFER | `cls1502Transfer` |
| [SQL-038](SQL-038.md) | Update an active benefit schedule | Inline | CL_BENEFIT_SCHEDULE | `clsActiveBenefitSchedule` |
| [SQL-039](SQL-039.md) | Update remaining payment count on a benefit payment (stop processing) | Inline | CL_BENEFIT_PAYMENT | `clsActiveBenefitSchedule` |
| [SQL-040](SQL-040.md) | Update an award benefit payment issue date | Inline | CL_BENEFIT_PAYMENT | `clsAwardBenefitPayment` |
| [SQL-041](SQL-041.md) | Update a benefit schedule (twin class) | Inline | CL_BENEFIT_SCHEDULE | `clsBenefitSchedule` |
| [SQL-042](SQL-042.md) | Update remaining payment count on a benefit payment (twin class) | Inline | CL_BENEFIT_PAYMENT | `clsBenefitSchedule` |
| [SQL-043](SQL-043.md) | Update a claim employee work address | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `clsClaimEmployeeWorkAddress` |
| [SQL-044](SQL-044.md) | Update a claim work-release-status row | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `clsClaimWorkReleaseStatus` |
| [SQL-045](SQL-045.md) | Update a claim work-status row | Inline | CL_CLAIM_WORK_STATUS | `clsClaimWorkStatus` |
| [SQL-046](SQL-046.md) | Update a federal award status | Inline | CL_FEDERAL_AWARD | `clsFederalAwardStatus` |
| [SQL-047](SQL-047.md) | Update a federal benefit schedule | Inline | CL_BENEFIT_SCHEDULE | `clsFederalBenefitSchedule` |
| [SQL-048](SQL-048.md) | Set an award status to Pending | Inline | CL_AWARD | `clsSetAwardPaymentPending` |
| [SQL-049](SQL-049.md) | Move an award's benefit payment to In Progress | Inline | CL_BENEFIT_PAYMENT | `clsSetAwardPaymentPending` |
| [SQL-050](SQL-050.md) | Update an injured body-part record | Inline | CL_WORKER_INJURED_BODY_PART | `clsWorkerInjuredBodyPart` |
| [SQL-051](SQL-051.md) | Propagate the primary body part to the injury claim | Inline | CL_INJURY_CLAIM | `clsWorkerInjuredBodyPart` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-052](SQL-052.md) | Delete a 1502 DCBS transfer record | Inline | CL_1502_DCBS_TRANSFER | `cls1502Transfer` |
| [SQL-053](SQL-053.md) | Delete an active benefit schedule | Inline | CL_BENEFIT_SCHEDULE | `clsActiveBenefitSchedule` |
| [SQL-054](SQL-054.md) | Delete a benefit payment (stop processing) | Inline | CL_BENEFIT_PAYMENT | `clsActiveBenefitSchedule` |
| [SQL-055](SQL-055.md) | Delete an award benefit payment | Inline | CL_BENEFIT_PAYMENT | `clsAwardBenefitPayment` |
| [SQL-056](SQL-056.md) | Delete a benefit schedule (twin class) | Inline | CL_BENEFIT_SCHEDULE | `clsBenefitSchedule` |
| [SQL-057](SQL-057.md) | Delete a benefit payment (twin class stop processing) | Inline | CL_BENEFIT_PAYMENT | `clsBenefitSchedule` |
| [SQL-058](SQL-058.md) | Delete a claim employee work address | Inline | CL_CLAIM_EMPLOYEE_WORK_ADDRESS | `clsClaimEmployeeWorkAddress` |
| [SQL-059](SQL-059.md) | Delete a claim work-release-status row | Inline | CL_CLAIM_WORK_RELEASE_STATUS | `clsClaimWorkReleaseStatus` |
| [SQL-060](SQL-060.md) | Delete a claim work-status row | Inline | CL_CLAIM_WORK_STATUS | `clsClaimWorkStatus` |
| [SQL-061](SQL-061.md) | Delete a federal benefit schedule | Inline | CL_BENEFIT_SCHEDULE | `clsFederalBenefitSchedule` |
| [SQL-062](SQL-062.md) | Delete an injured body-part record | Inline | CL_WORKER_INJURED_BODY_PART | `clsWorkerInjuredBodyPart` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001.md) | Get next 1502 transfer sequence value | `CL_1502_DCBS_TRANSFER_SEQ` | CL_1502_DCBS_TRANSFER | `cls1502Transfer` |
| [SQL-002](SQL-002.md) | Get next claim work-release-status sequence value | `CLAIM_WORK_REL_STATUS_SEQ_NUM` | CL_CLAIM_WORK_RELEASE_STATUS | `clsClaimWorkReleaseStatus` |
| [SQL-003](SQL-003.md) | Get next claim work-status sequence value | `CLAIM_WORK_STATUS_SEQ` | CL_CLAIM_WORK_STATUS | `clsClaimWorkStatus` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

## Sources
- SAIF.Business.Claim/cls1502Transfer.vb
- SAIF.Business.Claim/clsActiveBenefitSchedule.vb
- SAIF.Business.Claim/clsBenefitSchedule.vb